package demo;

import java.io.File;
import java.util.Arrays;
import java.util.List;

public class Main {

    public static final String PATH = "/Users/luckincoffee/Desktop/code/java-test/demo1/src/main/resources";
    public static final List<String> 门店库存统计表 = Arrays.asList("门店序号", "货物规格编码");
    public static final List<String> 门店进销存报表 = Arrays.asList("门店序号", "货物规格编码");
    public static final List<String> 门店信息表 = Arrays.asList("门店序号");
    public static final List<String> 门店开票主体信息表 = Arrays.asList("门店序号");
    public static final List<String> 非仓库非门店进销存报表 = Arrays.asList("部门名称", "货物规格编码");
    public static final List<String> 工程师零件进销存_新 = Arrays.asList("员工ID", "货物规格编号");
    public static final List<String> 仓库门店在途统计表 = Arrays.asList("配货单号调拨单号退货回调单号", "货物规格编号", "批次号");
    public static final List<String> 货物成本明细 = Arrays.asList("货物入库编号", "货物规格编号");
    public static final List<String> 非仓库门店库存变动表 = Arrays.asList("仓库编号", "货物规格编号");
    public static final List<String> 库房变动统计表 = Arrays.asList("仓库名称", "货物规格编号");
    public static final List<String> 仓库进销存报表 = Arrays.asList("仓库名称", "货物规格编码");
    public static final List<String> 采购退货 = Arrays.asList("退货单号", "规格编号");
    public static final List<String> 货物付款明细表 = Arrays.asList("采购单编号", "批次号", "付款编号", "货物规格编码");
    public static final List<String> 销售发货单 = Arrays.asList("销售发货单号", "货物规格编号");
    public static final List<String> 其他入库单 = Arrays.asList("其它入库单号", "货物规格编码");
    public static final List<String> 其他出库单 = Arrays.asList("其它出库单号", "货物规格编码", "出库批次");
    public static final List<String> 零件仓进销存 = Arrays.asList("支配部门名称", "存放部门NC编码", "库存单位编码", "货物规格编码");
    public static final List<String> 合作商提成明细 = Arrays.asList("门店序号", "账单开始日期", "账单结束日期");
    public static final List<String> 供应商发货单 = Arrays.asList("发货单编号");
    public static final List<String> 工程师零件进销存 = Arrays.asList("员工编号", "货物规格编号");
    public static final List<String> 充值单统计 = Arrays.asList("日期");
    public static final List<String> 预付客户充值报表 = Arrays.asList("企业名称", "付款方式");
    public static final List<String> 活动码对应订单分摊金额报表 = Arrays.asList("活动编码", "门店名称", "就餐形式", "实际订单类型", "订单渠道", "商品二级分类");
    public static final List<String> 咖啡库券当天新生成与API券码追踪差异明细 = Arrays.asList("咖啡库券编号");
    public static final List<String> 优惠券追踪表 = Arrays.asList("日期", "券来源", "券类型", "企业名称");
    public static final List<String> 咖啡库券追踪表 = Arrays.asList("type_date", "区域");
    public static final List<String> 咖啡库券开源统计表 = Arrays.asList("券来源", "企业编号", "运营区域");
    public static final List<String> 仓库库存调整记录 = Arrays.asList("操作时间", "规格编码", "总库存调整数量", "关联单据");
    public static final List<String> 调拨单 = Arrays.asList("调拨单号", "完成日期", "货物规格编码", "调拨批次");

    public static void main(String[] args) throws Exception {

//        String pathname1 = PATH + "/" + "财务-咖啡库券追踪表_2025-07-01_2025-07-31" + ".xlsx";
//        String pathname2 = PATH + "/" + "财务-咖啡库券追踪表_20250701_20250731" + ".xlsx";
////
//        String pathname1 = PATH + "/" + "财务-库存系统-调拨单_2025-08-01_2025-08-01.xlsx";
//        String pathname2 = PATH + "/" + "财务-库存系统-调拨单_20250701_20250731_指南针.xlsx";

        String pathname1 = PATH + "/" + "财务-咖啡库券追踪表_2025-08-01_2025-08-31_中台_v0909.xlsx";
        String pathname2 = PATH + "/" + "财务-咖啡库券追踪表_20250801_20250831_指南针_v0908.xlsx";

//        String pathname1 = PATH + "/" + "财务-咖啡库券追踪表_2025-08-01_2025-08-31_中台_2号导出.xlsx";
//        String pathname2 = PATH + "/" + "财务-咖啡库券追踪表_20250801_20250831_大数据_1号导出.xlsx";

        List<String> primaryKeys = 咖啡库券追踪表;
        String reportName = "咖啡库券追踪表";

        File file1 = new File(pathname1);
        File file2 = new File(pathname2);
        File outputDir = new File(PATH);
        ExcelDiffComparator.compare(file1, file2, primaryKeys, outputDir, reportName);
        System.out.println("Done.");
    }

}